﻿CREATE TABLE [dbo].[Resume]
(
	[UserId] [int] IDENTITY (1,1) NOT NULL,
	[DateUpdated] [datetime] NOT NULL DEFAULT (getdate()),
	[Code] varchar(20) NULL,
	[RealName] nvarchar(20) NOT NULL,
	[IsAudit] bit NOT NULL DEFAULT 0,
	[IsCommend] [bit] NOT NULL DEFAULT 0,
	[ResumeStatus] [nvarchar](4) NOT NULL DEFAULT (N'公开'),
	[SocialId] [nvarchar](50) NOT NULL,
	[Sex] [nvarchar](50) NOT NULL DEFAULT N'男',
	[BirthDate] [datetime] NOT NULL,
	[Height] [int] NOT NULL DEFAULT 160,
	[Weight] [int] NOT NULL DEFAULT 60,
	[Nation] [nvarchar](20) NULL,
	[Marriage] [nvarchar](10) NULL,
	[Party] [nvarchar](20) NULL DEFAULT(N'群众'),
	[Tel] [varchar](20) NULL,
	[Mobile] [varchar](20) NULL,
	[QQ] [varchar](20) NULL,
	[Zip] varchar(6) NULL,
	[Email] [varchar](100) NULL,
	[HomePage] varchar(200) NULL,
	[ResidentProvince] [nvarchar](50) NULL,
	[ResidentCity] [nvarchar](50) NULL,
	[ResidentPlace] [nvarchar](50) NULL,
	[Province] [nvarchar](50) NULL,
	[City] [nvarchar](50) NULL,
	[Town] [nvarchar](50) NULL,
	[Address] [nvarchar](200) NULL,
	[Status] [nvarchar](50) NULL,
	[JobType] nvarchar(4) NULL DEFAULT N'全职',
	[JobClass] [nvarchar](50) NOT NULL,
	[JobKeywordsStr] [nvarchar](400) NULL,
	[Place] [nvarchar](50) NULL,
	[CurrentMonthSalary] int NULL,
	[WishMonthSalaryFrom] [int] NOT NULL DEFAULT 0,
	[WishMonthSalaryTo] [int] NOT NULL DEFAULT 0,
	[House] [bit] NOT NULL DEFAULT 0,
	[Education] [nvarchar](20) NULL,
	[School] [nvarchar](50) NULL,
	[MajorName] [nvarchar](20) NULL,
	[GraduatedTime] datetime NOT NULL,
	[ProfessionalTitle] [nvarchar](20) NULL,
	[Lang1] [nvarchar](20) NULL,
	[Lang2] [nvarchar](20) NULL,
	[Lang1Level] [nvarchar](20) NULL,
	[Lang2Level] [nvarchar](20) NULL,
	[ComputerLevel] [nvarchar](20) NULL,
	[Chinese] [nvarchar](20) NULL,
	[Driver] [nvarchar](20) NULL,
	[Cert] [nvarchar](20) NULL,
	[YearsWorked] [int] NOT NULL DEFAULT 0,
	[WorkNote] nvarchar(4000) NULL,
	[TrainingNote] [ntext] NULL,
	[ShowResumeDays] [int] NOT NULL DEFAULT 30,
	[ViewCount] [int] NOT NULL DEFAULT 0,
	[Photo] [varchar](200) NULL,
	[PhotoChecked] [bit] NOT NULL DEFAULT 0,
	[ForbiddenCompanyName] nvarchar(50) NULL
);
